﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Configuration;
using Manager;

using System.Data.SqlClient;

namespace DataAccess
{
    public sealed class RoomDAC
    {
        public static SqlDataReader GetRoomInformation()
        {
            SqlDataReader reader;

            string sql = "SELECT * FROM Building";
            
            using (SqlCommand command = new SqlCommand(sql, ConnectionManager.GetConnection()))
            {
                reader = command.ExecuteReader(CommandBehavior.SingleResult | CommandBehavior.CloseConnection);
            }
            return reader;
        }
    }
}